﻿<%@ Page Title="" Language="C#" MasterPageFile="~/Master/Site.Master" AutoEventWireup="true" CodeBehind="BorrowInfo.aspx.cs" Inherits="聚欣订单分析.Borrow.BorrowInfo" %>

<%@ Register Assembly="DevExpress.Web.v18.1, Version=18.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Data.Linq" TagPrefix="dx" %>

<%@ Register Assembly="DevExpress.Web.v18.1, Version=18.1.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CPH_NAV" runat="server">
    <h2>借货明细</h2>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="CPH_Contents" runat="server">
    <div class="content-page">
        <div class="content">
            <div class="am-g">
                <!-- Row start -->
                <div class="card-box">
                    <dx:ASPxGridView ID="ASPxGridView1" runat="server" Width="100%" DataSourceID="LinqServerModeDataSource1" AutoGenerateColumns="False">
                        <SettingsAdaptivity>
                            <AdaptiveDetailLayoutProperties ColCount="1"></AdaptiveDetailLayoutProperties>
                        </SettingsAdaptivity>
                        <EditFormLayoutProperties ColCount="1"></EditFormLayoutProperties>
                        <Columns>
                            <dx:GridViewDataTextColumn FieldName="协议编号" VisibleIndex="0" Width="100px">
                                <Settings AutoFilterCondition="Contains" />
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="物品" VisibleIndex="1">
                                <Settings AutoFilterCondition="Contains" />
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="数量" VisibleIndex="2" Width="50px">
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                             <dx:GridViewDataCheckColumn Caption="长期?" FieldName="长期" VisibleIndex="3" Width="50px">
                                 <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                                <PropertiesCheckEdit DisplayTextChecked="是" DisplayTextUnchecked="否">
                                </PropertiesCheckEdit>
                            </dx:GridViewDataCheckColumn>
                            <dx:GridViewDataTextColumn FieldName="借货类型" VisibleIndex="4" Width="70px">
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataDateColumn FieldName="借货日期" VisibleIndex="5">
                                <Settings AllowHeaderFilter="True" />
                            </dx:GridViewDataDateColumn>
                             <dx:GridViewDataComboBoxColumn FieldName="区域" VisibleIndex="5">
                                <PropertiesComboBox>
                                    <Items>
                                        <dx:ListEditItem Text="江苏" Value="江苏" />
                                        <dx:ListEditItem Text="安徽" Value="安徽" />
                                        <dx:ListEditItem Text="山东" Value="山东" />
                                        <dx:ListEditItem Text="湖北" Value="湖北" />
                                    </Items>
                                </PropertiesComboBox>
                            </dx:GridViewDataComboBoxColumn>
                            <dx:GridViewDataTextColumn FieldName="借货人" VisibleIndex="6">
                                <Settings AutoFilterCondition="Contains" />
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="金额" VisibleIndex="8" Width="50px">
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="利息" VisibleIndex="9" Width="50px">
                                <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataDateColumn FieldName="归还日期" VisibleIndex="10">
                                <Settings AllowHeaderFilter="True" />
                            </dx:GridViewDataDateColumn>
                           <dx:GridViewDataCheckColumn Caption="归转?" FieldName="归还" VisibleIndex="11" Width="50px">
                               <SettingsHeaderFilter Mode="CheckedList"></SettingsHeaderFilter>
                                <EditFormSettings Visible="False" />
                                <PropertiesCheckEdit DisplayTextChecked="是" DisplayTextUnchecked="否">
                                </PropertiesCheckEdit>
                            </dx:GridViewDataCheckColumn>
                            <dx:GridViewDataTextColumn FieldName="已借天" ReadOnly="True" VisibleIndex="12" Width="50px">
                                <SettingsHeaderFilter Mode="List"></SettingsHeaderFilter>
                            </dx:GridViewDataTextColumn>
                               <dx:GridViewDataTextColumn FieldName="合同号" VisibleIndex="13">
                                <Settings AutoFilterCondition="Contains" />
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="用途" VisibleIndex="13">
                                <Settings AutoFilterCondition="Contains" />
                            </dx:GridViewDataTextColumn>
                            <dx:GridViewDataTextColumn FieldName="备注" VisibleIndex="14">
                                <Settings AutoFilterCondition="Contains" />
                            </dx:GridViewDataTextColumn>
                             <dx:GridViewCommandColumn ShowClearFilterButton="True" VisibleIndex="15">
                            </dx:GridViewCommandColumn>
                        </Columns>
                        <GroupSummary>
                            <dx:ASPxSummaryItem FieldName="物品" SummaryType="Count" DisplayFormat="数量:{0}" />
                        </GroupSummary>
                        <SettingsPopup>
                            <HeaderFilter>
                                <SettingsAdaptivity Mode="Off" SwitchAtWindowInnerWidth="768" />
                            </HeaderFilter>
                        </SettingsPopup>
                        <Settings ShowFilterRow="True" ShowFilterRowMenu="true" ShowFilterBar="Visible" ShowGroupPanel="true" />
                    </dx:ASPxGridView>
                       <table style="margin-top:5px">
                        <tr>
                            <td>
                                <dx:ASPxButton ID="btnExcel" runat="server" Text="导出Excel" OnClick="btnExcel_Click">
                                    <Image Url="~/images/ICON/Excel.gif">
                                    </Image>
                                </dx:ASPxButton>
                            </td>
                        </tr>
                    </table>
                </div>
            </div>
        </div>
    </div>
     <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" GridViewID="ASPxGridView1" runat="server">
    </dx:ASPxGridViewExporter>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:JXDDConnectionString %>" SelectCommand="SELECT * FROM [v_JHWP]"></asp:SqlDataSource>
    <dx:LinqServerModeDataSource ID="LinqServerModeDataSource1" runat="server" ContextTypeName="聚欣订单分析.Ling.tbl_JHDataContext" DefaultSorting="协议编号 desc" TableName="v_JHWP" OnSelecting="LinqServerModeDataSource1_Selecting" />
</asp:Content>
